package org.edu.modules.scheduleCommon.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.edu.modules.scheduleCommon.entity.VeBaseBanji;

import java.util.List;

/**
 * dao-班级信息表
 */
@Mapper
public interface VeBaseBanjiMapper extends BaseMapper<VeBaseBanji> {

    /**
     * 查询实体类
     */
    VeBaseBanji findById(@Param("id") Integer id);

    //根据专业查班级
    List<VeBaseBanji> getBanJiListBySpecId(@Param("specId") Integer specId);

    //根据班主任userId（教师表user_id）查班级
    List<VeBaseBanji> listByTeacherId(@Param("userId") String userId);

    //根据教师userId（教师表user_id）查教学班级
    List<VeBaseBanji> getBanJiListBySemIdAndTeacherId(@Param("semId") Integer semId, @Param("userId") String userId);
}
